<?php
class RP_Model_DbTable_CourseSpec extends Zend_Db_Table_Abstract
{
	 protected $_name = 'course_spec';
	 
	 public function fetchCourseSpecializations($course_id){
		$sql = "SELECT cs.edu_spec_id, es.edu_spec_name
					FROM course_spec cs
					INNER JOIN edu_spec es ON ( cs.edu_spec_id = es.edu_spec_id )
					WHERE cs.course_id = \"$course_id\" ";
	 	
	 	return $this->getAdapter()->query($sql)->fetchAll();
	 }
}
?>